Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	35798
Missing cells	61436
Missing cells (%)	14.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.3 MiB
Average record size in memory	96.0 B

Variable types

Categorical	2
Numeric	10

Warnings

`INSEE commune` has a high cardinality: 35798 distinct values	High cardinality
`Commune` has a high cardinality: 33338 distinct values	High cardinality
`Résidentiel` is highly correlated with `Tertiaire`	High correlation
`Tertiaire` is highly correlated with `Résidentiel`	High correlation
`Autres transports` has 25819 (72.1%) missing values	Missing
`Autres transports international` has 32907 (91.9%) missing values	Missing
`Energie` has 1308 (3.7%) missing values	Missing
`Industrie hors-énergie` has 1308 (3.7%) missing values	Missing
`Autres transports` is highly skewed (γ1 = 32.95394514)	Skewed
`Autres transports international` is highly skewed (γ1 = 22.76243785)	Skewed
`CO2 biomasse hors-total` is highly skewed (γ1 = 25.19224145)	Skewed
`Déchets` is highly skewed (γ1 = 29.28677041)	Skewed
`Energie` is highly skewed (γ1 = 72.79009042)	Skewed
`Industrie hors-énergie` is highly skewed (γ1 = 89.5297339)	Skewed
`INSEE commune` is uniformly distributed	Uniform
`Commune` is uniformly distributed	Uniform
`INSEE commune` has unique values	Unique
`CO2 biomasse hors-total` has unique values	Unique

Reproduction

Analysis started	2021-02-18 21:33:48.972481
Analysis finished	2021-02-18 21:34:03.604077
Duration	14.63 seconds
Software version	pandas-profiling v2.10.0
Download configuration	config.yaml

INSEE commune
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	35798
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	279.8 KiB

19227	1
63161	1
29011	1
47027	1
65408	1
Other values (35793)	35793

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	178990
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	35798 ?
Unique (%)	100.0%

Sample

1st row	01001
2nd row	01002
3rd row	01004
4th row	01005
5th row	01006

Value	Count	Frequency (%)
19227	1	< 0.1%
63161	1	< 0.1%
29011	1	< 0.1%
47027	1	< 0.1%
65408	1	< 0.1%
80814	1	< 0.1%
31461	1	< 0.1%
29296	1	< 0.1%
62242	1	< 0.1%
59072	1	< 0.1%
Other values (35788)	35788	> 99.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
19227	1	< 0.1%
80395	1	< 0.1%
02188	1	< 0.1%
48174	1	< 0.1%
76477	1	< 0.1%
63056	1	< 0.1%
58302	1	< 0.1%
09077	1	< 0.1%
76026	1	< 0.1%
63161	1	< 0.1%
Other values (35788)	35788	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	23687	13.2%
2	23145	12.9%
0	22832	12.8%
3	19023	10.6%
5	17370	9.7%
4	16956	9.5%
6	16008	8.9%
7	15274	8.5%
8	13628	7.6%
9	10707	6.0%
Other values (2)	360	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	178630	99.8%
Uppercase Letter	360	0.2%

Most frequent character per category

Value	Count	Frequency (%)
1	23687	13.3%
2	23145	13.0%
0	22832	12.8%
3	19023	10.6%
5	17370	9.7%
4	16956	9.5%
6	16008	9.0%
7	15274	8.6%
8	13628	7.6%
9	10707	6.0%

Value	Count	Frequency (%)
B	236	65.6%
A	124	34.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	178630	99.8%
Latin	360	0.2%

Most frequent character per script

Value	Count	Frequency (%)
1	23687	13.3%
2	23145	13.0%
0	22832	12.8%
3	19023	10.6%
5	17370	9.7%
4	16956	9.5%
6	16008	9.0%
7	15274	8.6%
8	13628	7.6%
9	10707	6.0%

Value	Count	Frequency (%)
B	236	65.6%
A	124	34.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	178990	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	23687	13.2%
2	23145	12.9%
0	22832	12.8%
3	19023	10.6%
5	17370	9.7%
4	16956	9.5%
6	16008	8.9%
7	15274	8.5%
8	13628	7.6%
9	10707	6.0%
Other values (2)	360	0.2%

Commune
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	33338
Distinct (%)	93.1%
Missing	0
Missing (%)	0.0%
Memory size	279.8 KiB

SAINTE-COLOMBE	13
SAINT-SAUVEUR	11
LE PIN	10
SAINT-AUBIN	10
BEAULIEU	10
Other values (33333)	35744

Length

Max length	45
Median length	10
Mean length	11.76677468
Min length	1

Characters and Unicode

Total characters	421227
Distinct characters	41
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	31762 ?
Unique (%)	88.7%

Sample

1st row	L'ABERGEMENT-CLEMENCIAT
2nd row	L'ABERGEMENT-DE-VAREY
3rd row	AMBERIEU-EN-BUGEY
4th row	AMBERIEUX-EN-DOMBES
5th row	AMBLEON

Value	Count	Frequency (%)
SAINTE-COLOMBE	13	< 0.1%
SAINT-SAUVEUR	11	< 0.1%
LE PIN	10	< 0.1%
SAINT-AUBIN	10	< 0.1%
BEAULIEU	10	< 0.1%
SAINT-REMY	10	< 0.1%
SAINT-LOUP	10	< 0.1%
BEAUMONT	9	< 0.1%
SAINT-MICHEL	9	< 0.1%
SAINT-MARCEL	9	< 0.1%
Other values (33328)	35697	99.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
la	1092	2.9%
le	782	2.0%
les	336	0.9%
de	22	0.1%
val	18	< 0.1%
en	16	< 0.1%
sainte-colombe	13	< 0.1%
saint-sauveur	11	< 0.1%
pin	11	< 0.1%
saint-remy	10	< 0.1%
Other values (33207)	35906	94.0%

Most occurring characters

Value	Count	Frequency (%)
E	53315	12.7%
A	37271	8.8%
N	31465	7.5%
L	30297	7.2%
S	30118	7.2%
R	29546	7.0%
I	28390	6.7%
-	25771	6.1%
O	22346	5.3%
U	20779	4.9%
Other values (31)	111929	26.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	392121	93.1%
Dash Punctuation	25771	6.1%
Space Separator	2419	0.6%
Other Punctuation	841	0.2%
Decimal Number	63	< 0.1%
Open Punctuation	6	< 0.1%
Close Punctuation	6	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
E	53315	13.6%
A	37271	9.5%
N	31465	8.0%
L	30297	7.7%
S	30118	7.7%
R	29546	7.5%
I	28390	7.2%
O	22346	5.7%
U	20779	5.3%
T	19960	5.1%
Other values (16)	88634	22.6%

Value	Count	Frequency (%)
1	22	34.9%
2	6	9.5%
3	5	7.9%
4	5	7.9%
5	5	7.9%
6	5	7.9%
7	4	6.3%
8	4	6.3%
9	4	6.3%
0	3	4.8%

Value	Count	Frequency (%)
'	841	100.0%

Value	Count	Frequency (%)
-	25771	100.0%

Value	Count	Frequency (%)
	2419	100.0%

Value	Count	Frequency (%)
(	6	100.0%

Value	Count	Frequency (%)
)	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	392121	93.1%
Common	29106	6.9%

Most frequent character per script

Value	Count	Frequency (%)
E	53315	13.6%
A	37271	9.5%
N	31465	8.0%
L	30297	7.7%
S	30118	7.7%
R	29546	7.5%
I	28390	7.2%
O	22346	5.7%
U	20779	5.3%
T	19960	5.1%
Other values (16)	88634	22.6%

Value	Count	Frequency (%)
-	25771	88.5%
	2419	8.3%
'	841	2.9%
1	22	0.1%
2	6	< 0.1%
(	6	< 0.1%
)	6	< 0.1%
3	5	< 0.1%
4	5	< 0.1%
5	5	< 0.1%
Other values (5)	20	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	421227	100.0%

Most frequent character per block

Value	Count	Frequency (%)
E	53315	12.7%
A	37271	8.8%
N	31465	7.5%
L	30297	7.2%
S	30118	7.2%
R	29546	7.0%
I	28390	6.7%
-	25771	6.1%
O	22346	5.3%
U	20779	4.9%
Other values (31)	111929	26.6%

Agriculture
Real number (ℝ_≥0)

Distinct	35576
Distinct (%)	99.6%
Missing	62
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%

Mean	2459.97576
Minimum	0.003431569
Maximum	98949.31776
Zeros	0
Zeros (%)	0.0%
Memory size	279.8 KiB

Quantile statistics

Minimum	0.003431569
5-th percentile	198.1526881
Q1	797.6826308
median	1559.381286
Q3	3007.883903
95-th percentile	7846.964087
Maximum	98949.31776
Range	98949.31433
Interquartile range (IQR)	2210.201272

Descriptive statistics

Standard deviation	2926.957701
Coefficient of variation (CV)	1.189831928
Kurtosis	60.09142074
Mean	2459.97576
Median Absolute Deviation (MAD)	930.7634055
Skewness	4.604079434
Sum	87909693.75
Variance	8567081.385
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.78188548	28	0.1%
3.30849485	24	0.1%
303.8369644	16	< 0.1%
294.5763329	14	< 0.1%
23.41429158	9	< 0.1%
48.36102526	8	< 0.1%
1000.652204	5	< 0.1%
63.16232461	5	< 0.1%
452.4630027	4	< 0.1%
570.4404755	3	< 0.1%
Other values (35566)	35620	99.5%
(Missing)	62	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.003431569	1	< 0.1%
0.004829911	1	< 0.1%
0.010140325	1	< 0.1%
0.032444209	1	< 0.1%
0.038848797	1	< 0.1%

Value	Count	Frequency (%)
98949.31776	1	< 0.1%
70939.75763	1	< 0.1%
53369.58721	1	< 0.1%
42827.36037	1	< 0.1%
40087.43192	1	< 0.1%

Autres transports
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	9963
Distinct (%)	99.8%
Missing	25819
Missing (%)	72.1%
Infinite	0
Infinite (%)	0.0%

Mean	654.9199401
Minimum	0.000204496
Maximum	513140.9717
Zeros	0
Zeros (%)	0.0%
Memory size	279.8 KiB

Quantile statistics

Minimum	0.000204496
5-th percentile	12.28979284
Q1	52.56041173
median	106.7959278
Q3	237.3415008
95-th percentile	766.3351019
Maximum	513140.9717
Range	513140.9715
Interquartile range (IQR)	184.7810891

Descriptive statistics

Standard deviation	9232.816833
Coefficient of variation (CV)	14.0976267
Kurtosis	1364.758616
Mean	654.9199401
Median Absolute Deviation (MAD)	69.05188221
Skewness	32.95394514
Sum	6535446.083
Variance	85244906.67
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
133.2385454	2	< 0.1%
261.2422255	2	< 0.1%
44.74586658	2	< 0.1%
49.09646127	2	< 0.1%
62.63068772	2	< 0.1%
69.18166898	2	< 0.1%
111.2393401	2	< 0.1%
119.5499688	2	< 0.1%
83.08275351	2	< 0.1%
60.98852678	2	< 0.1%
Other values (9953)	9959	27.8%
(Missing)	25819	72.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.000204496	1	< 0.1%
0.000678228	1	< 0.1%
0.001757375	1	< 0.1%
0.001966236	1	< 0.1%
0.00524676	1	< 0.1%

Value	Count	Frequency (%)
513140.9717	1	< 0.1%
308100.1638	1	< 0.1%
271182.7586	1	< 0.1%
270757.665	1	< 0.1%
245375.4187	1	< 0.1%

Autres transports international
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	2883
Distinct (%)	99.7%
Missing	32907
Missing (%)	91.9%
Infinite	0
Infinite (%)	0.0%

Mean	7692.34496
Minimum	0.000397295
Maximum	3303393.666
Zeros	0
Zeros (%)	0.0%
Memory size	279.8 KiB

Quantile statistics

Minimum	0.000397295
5-th percentile	2.140943147
Q1	10.05096686
median	19.92434287
Q3	32.98311078
95-th percentile	208.5806101
Maximum	3303393.666
Range	3303393.666
Interquartile range (IQR)	22.93214392

Descriptive statistics

Standard deviation	113764.3095
Coefficient of variation (CV)	14.78928858
Kurtosis	584.308405
Mean	7692.34496
Median Absolute Deviation (MAD)	10.86458724
Skewness	22.76243785
Sum	22238569.28
Variance	1.294231811 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27.16194484	2	< 0.1%
27.01176734	2	< 0.1%
3303393.666	2	< 0.1%
0.436627175	2	< 0.1%
9.271196017	2	< 0.1%
23.76109987	2	< 0.1%
65.99887919	2	< 0.1%
16.1772156	2	< 0.1%
7.553689851	1	< 0.1%
63.2073258	1	< 0.1%
Other values (2873)	2873	8.0%
(Missing)	32907	91.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.000397295	1	< 0.1%
0.011918849	1	< 0.1%
0.038934907	1	< 0.1%
0.045768381	1	< 0.1%
0.068175817	1	< 0.1%

Value	Count	Frequency (%)
3303393.666	2	< 0.1%
2202274.837	1	< 0.1%
2109460.026	1	< 0.1%
1101145.545	1	< 0.1%
1101131.222	1	< 0.1%

CO2 biomasse hors-total
Real number (ℝ_≥0)

SKEWED
UNIQUE

Distinct	35798
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1774.38155
Minimum	3.758087577
Maximum	576394.1812
Zeros	0
Zeros (%)	0.0%
Memory size	279.8 KiB

Quantile statistics

Minimum	3.758087577
5-th percentile	79.00816519
Q1	197.9511085
median	424.8499878
Q3	1094.749826
95-th percentile	6276.826891
Maximum	576394.1812
Range	576390.4231
Interquartile range (IQR)	896.7987173

Descriptive statistics

Standard deviation	7871.341922
Coefficient of variation (CV)	4.436104469
Kurtosis	1174.072663
Mean	1774.38155
Median Absolute Deviation (MAD)	285.9307994
Skewness	25.19224145
Sum	63519310.72
Variance	61958023.66
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
183.2411592	1	< 0.1%
142.6446843	1	< 0.1%
3092.692008	1	< 0.1%
205.9905387	1	< 0.1%
200.6592781	1	< 0.1%
3261.579469	1	< 0.1%
660.2999911	1	< 0.1%
1219.957265	1	< 0.1%
1121.624203	1	< 0.1%
339.675638	1	< 0.1%
Other values (35788)	35788	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.758087577	1	< 0.1%
7.162928197	1	< 0.1%
7.608032151	1	< 0.1%
7.96333366	1	< 0.1%
8.260098417	1	< 0.1%

Value	Count	Frequency (%)
576394.1812	1	< 0.1%
371375.0394	1	< 0.1%
273607.0952	1	< 0.1%
256360.5826	1	< 0.1%
253079.4422	1	< 0.1%

Déchets
Real number (ℝ_≥0)

SKEWED

Distinct	11016
Distinct (%)	30.8%
Missing	6
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	410.8063294
Minimum	0.132243124
Maximum	275500.3744
Zeros	0
Zeros (%)	0.0%
Memory size	279.8 KiB

Quantile statistics

Minimum	0.132243124
5-th percentile	9.918234329
Q1	25.65516613
median	54.7486535
Q3	110.8209407
95-th percentile	246.5316813
Maximum	275500.3744
Range	275500.2422
Interquartile range (IQR)	85.16577452

Descriptive statistics

Standard deviation	4122.472608
Coefficient of variation (CV)	10.03507569
Kurtosis	1275.554838
Mean	410.8063294
Median Absolute Deviation (MAD)	34.77994171
Skewness	29.28677041
Sum	14703580.14
Variance	16994780.4
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11.63739495	71	0.2%
16.53039055	70	0.2%
17.58833554	65	0.2%
18.77852366	61	0.2%
14.67898681	60	0.2%
12.29861057	60	0.2%
16.39814742	59	0.2%
19.43973928	59	0.2%
13.88552806	59	0.2%
20.10095491	58	0.2%
Other values (11006)	35170	98.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.132243124	1	< 0.1%
0.264486249	1	< 0.1%
0.396729373	1	< 0.1%
0.528972498	1	< 0.1%
0.661215622	2	< 0.1%

Value	Count	Frequency (%)
275500.3744	1	< 0.1%
221513.8458	1	< 0.1%
187087.7231	1	< 0.1%
171483.5912	1	< 0.1%
170815.24	1	< 0.1%

Energie
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	1453
Distinct (%)	4.2%
Missing	1308
Missing (%)	3.7%
Infinite	0
Infinite (%)	0.0%

Mean	662.5698463
Minimum	2.354557741
Maximum	2535857.559
Zeros	0
Zeros (%)	0.0%
Memory size	279.8 KiB

Quantile statistics

Minimum	2.354557741
5-th percentile	2.354557741
Q1	2.354557741
median	4.709115482
Q3	51.80027031
95-th percentile	958.3050007
Maximum	2535857.559
Range	2535855.204
Interquartile range (IQR)	49.44571257

Descriptive statistics

Standard deviation	26455.71422
Coefficient of variation (CV)	39.9289439
Kurtosis	5774.498622
Mean	662.5698463
Median Absolute Deviation (MAD)	2.354557741
Skewness	72.79009042
Sum	22852034
Variance	699904815.1
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.354557741	17013	47.5%
4.709115482	1354	3.8%
7.063673224	1174	3.3%
9.418230965	845	2.4%
11.77278871	764	2.1%
14.12734645	574	1.6%
16.48190419	527	1.5%
18.83646193	441	1.2%
21.19101967	411	1.1%
23.54557741	334	0.9%
Other values (1443)	11053	30.9%
(Missing)	1308	3.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.354557741	17013	47.5%
4.709115482	1354	3.8%
7.063673224	1174	3.3%
9.418230965	845	2.4%
11.77278871	764	2.1%

Value	Count	Frequency (%)
2535857.559	1	< 0.1%
2296710.801	1	< 0.1%
1934988.247	1	< 0.1%
1570236.21	1	< 0.1%
1363401.934	1	< 0.1%

Industrie hors-énergie
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	1889
Distinct (%)	5.5%
Missing	1308
Missing (%)	3.7%
Infinite	0
Infinite (%)	0.0%

Mean	2423.127789
Minimum	1.052998302
Maximum	6765118.848
Zeros	0
Zeros (%)	0.0%
Memory size	279.8 KiB

Quantile statistics

Minimum	1.052998302
5-th percentile	6.911213351
Q1	6.911213351
median	13.8224267
Q3	152.0466937
95-th percentile	3434.873035
Maximum	6765118.848
Range	6765117.795
Interquartile range (IQR)	145.1354803

Descriptive statistics

Standard deviation	56703.73779
Coefficient of variation (CV)	23.40105134
Kurtosis	9680.614239
Mean	2423.127789
Median Absolute Deviation (MAD)	6.911213349
Skewness	89.5297339
Sum	83573677.44
Variance	3215313880
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.911213351	16989	47.5%
13.8224267	1354	3.8%
20.73364005	1172	3.3%
27.6448534	842	2.4%
34.55606675	763	2.1%
41.4672801	573	1.6%
48.37849345	527	1.5%
55.28970681	441	1.2%
62.20092016	410	1.1%
69.11213351	334	0.9%
Other values (1879)	11085	31.0%
(Missing)	1308	3.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.052998302	1	< 0.1%
1.424488779	1	< 0.1%
3.599994427	1	< 0.1%
3.916178318	1	< 0.1%
4.649902607	1	< 0.1%

Value	Count	Frequency (%)
6765118.848	1	< 0.1%
5997332.978	1	< 0.1%
2380184.927	1	< 0.1%
2005643.488	1	< 0.1%
1875871.693	1	< 0.1%

Résidentiel
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	35791
Distinct (%)	> 99.9%
Missing	6
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	1783.677872
Minimum	1.027266053
Maximum	410675.902
Zeros	0
Zeros (%)	0.0%
Memory size	279.8 KiB

Quantile statistics

Minimum	1.027266053
5-th percentile	34.06354299
Q1	96.05291132
median	227.0911926
Q3	749.4692931
95-th percentile	6615.577065
Maximum	410675.902
Range	410674.8747
Interquartile range (IQR)	653.4163818

Descriptive statistics

Standard deviation	8915.902378
Coefficient of variation (CV)	4.998605701
Kurtosis	507.7795831
Mean	1783.677872
Median Absolute Deviation (MAD)	166.0310362
Skewness	18.30322831
Sum	63841398.38
Variance	79493315.22
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.51474463	2	< 0.1%
255.2761423	1	< 0.1%
803.0017076	1	< 0.1%
415.0475222	1	< 0.1%
327.6775641	1	< 0.1%
96.05702127	1	< 0.1%
668.7796976	1	< 0.1%
113.2162217	1	< 0.1%
145.2669155	1	< 0.1%
371.3201602	1	< 0.1%
Other values (35781)	35781	> 99.9%
(Missing)	6	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.027266053	1	< 0.1%
1.708651818	1	< 0.1%
2.084472141	1	< 0.1%
2.224000127	1	< 0.1%
2.294000724	1	< 0.1%

Value	Count	Frequency (%)
410675.902	1	< 0.1%
354259.0138	1	< 0.1%
353586.4246	1	< 0.1%
307642.4107	1	< 0.1%
265526.454	1	< 0.1%

Routier
Real number (ℝ_≥0)

Distinct	35749
Distinct (%)	99.9%
Missing	20
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	3535.501245
Minimum	0.555092164
Maximum	586054.6728
Zeros	0
Zeros (%)	0.0%
Memory size	279.8 KiB

Quantile statistics

Minimum	0.555092164
5-th percentile	126.1394469
Q1	419.7004599
median	1070.895593
Q3	3098.612157
95-th percentile	13930.8568
Maximum	586054.6728
Range	586054.1177
Interquartile range (IQR)	2678.911697

Descriptive statistics

Standard deviation	9663.156628
Coefficient of variation (CV)	2.733178681
Kurtosis	553.1785582
Mean	3535.501245
Median Absolute Deviation (MAD)	813.5683708
Skewness	15.83081944
Sum	126493163.5
Variance	93376596.01
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35324.12913	16	< 0.1%
42625.84606	9	< 0.1%
3.683377066	2	< 0.1%
2.896997387	2	< 0.1%
3.960923817	2	< 0.1%
4.261598642	2	< 0.1%
2.41129113	2	< 0.1%
2.781352422	2	< 0.1%
752.1131502	1	< 0.1%
541.6091186	1	< 0.1%
Other values (35739)	35739	99.8%
(Missing)	20	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.555092164	1	< 0.1%
0.647607622	1	< 0.1%
0.809509295	1	< 0.1%
0.8557673	1	< 0.1%
0.902024756	1	< 0.1%

Value	Count	Frequency (%)
586054.6728	1	< 0.1%
352836.8643	1	< 0.1%
279544.8523	1	< 0.1%
265561.1836	1	< 0.1%
263743.3139	1	< 0.1%

Tertiaire
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	8663
Distinct (%)	24.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1105.165915
Minimum	0
Maximum	288175.4001
Zeros	6
Zeros (%)	< 0.1%
Memory size	279.8 KiB

Quantile statistics

Minimum	0
5-th percentile	33.49743424
Q1	94.74988543
median	216.2977182
Q3	576.155869
95-th percentile	3972.063794
Maximum	288175.4001
Range	288175.4001
Interquartile range (IQR)	481.4059836

Descriptive statistics

Standard deviation	5164.182507
Coefficient of variation (CV)	4.672766718
Kurtosis	617.0161261
Mean	1105.165915
Median Absolute Deviation (MAD)	152.6525931
Skewness	19.71232093
Sum	39562729.44
Variance	26668780.97
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42.11106019	81	0.2%
59.81684686	81	0.2%
72.73728578	74	0.2%
63.64512506	74	0.2%
59.33831209	74	0.2%
67.95193803	72	0.2%
50.24615136	72	0.2%
53.11736001	71	0.2%
61.25245118	69	0.2%
70.34461191	68	0.2%
Other values (8653)	35062	97.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6	< 0.1%
0.478534775	1	< 0.1%
0.95706955	1	< 0.1%
1.435604325	1	< 0.1%
1.9141391	2	< 0.1%

Value	Count	Frequency (%)
288175.4001	1	< 0.1%
179562.7614	1	< 0.1%
175581.619	1	< 0.1%
173447.5828	1	< 0.1%
171766.4354	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	INSEE commune	Commune	Agriculture	Autres transports	Autres transports international	CO2 biomasse hors-total	Déchets	Energie	Industrie hors-énergie	Résidentiel	Routier	Tertiaire
0	01001	L'ABERGEMENT-CLEMENCIAT	3711.425991	NaN	NaN	432.751835	101.430476	2.354558	6.911213	309.358195	793.156501	367.036172
1	01002	L'ABERGEMENT-DE-VAREY	475.330205	NaN	NaN	140.741660	140.675439	2.354558	6.911213	104.866444	348.997893	112.934207
2	01004	AMBERIEU-EN-BUGEY	499.043526	212.577909	NaN	10313.446520	5314.314445	998.332482	2930.354461	16616.822530	15642.420310	10732.376930
3	01005	AMBERIEUX-EN-DOMBES	1859.160954	NaN	NaN	1144.429311	216.217508	94.182310	276.448534	663.683146	1756.341319	782.404357
4	01006	AMBLEON	448.966808	NaN	NaN	77.033834	48.401549	NaN	NaN	43.714019	398.786800	51.681756
5	01007	AMBRONAY	4390.996698	132.968268	NaN	3067.245459	6144.186081	122.437002	359.383094	1898.638273	22481.123580	2789.133106
6	01008	AMBUTRIX	489.648726	60.233517	NaN	558.055709	98.388885	2.354558	6.911213	495.393592	3616.168396	356.029873
7	01009	ANDERT-ET-CONDON	676.468367	NaN	NaN	207.181968	149.767083	2.354558	6.911213	141.533662	696.956038	161.266219
8	01010	ANGLEFORT	1070.411510	143.815664	NaN	1286.621447	146.525382	341.410872	175185.892500	448.518801	3199.808360	1206.147643
9	01011	APREMONT	2010.790441	NaN	NaN	249.086914	52.103791	2.354558	6.911213	151.844891	686.153720	188.542701

Last rows

	INSEE commune	Commune	Agriculture	Autres transports	Autres transports international	CO2 biomasse hors-total	Déchets	Energie	Industrie hors-énergie	Résidentiel	Routier	Tertiaire
35788	95652	VIARMES	252.094735	55.168176	NaN	1278.247866	43.526914	40.027482	117.490627	6546.179324	5705.777606	2521.399729
35789	95656	VIENNE-EN-ARTHIES	324.827105	NaN	NaN	98.346155	57.129030	2.354558	6.911213	158.726900	305.819555	206.727023
35790	95658	VIGNY	1289.190261	NaN	NaN	1616.838995	2297.572718	313.156180	919.191376	1424.373138	8539.961119	516.817557
35791	95660	VILLAINES-SOUS-BOIS	447.132894	18.996282	NaN	207.294216	92.966916	11.772789	34.556067	1023.037832	912.992023	336.409947
35792	95675	VILLERON	1335.123315	4.975886	NaN	1625.523404	104.075339	320.219853	939.925016	617.177184	7740.572805	725.467969
35793	95676	VILLERS-EN-ARTHIES	1628.065094	NaN	NaN	165.045396	65.063617	11.772789	34.556067	176.098160	309.627908	235.439109
35794	95678	VILLIERS-ADAM	698.630772	NaN	NaN	1331.126598	111.480954	2.354558	6.911213	1395.529811	18759.370070	403.404815
35795	95680	VILLIERS-LE-BEL	107.564967	NaN	NaN	8367.174532	225.622903	534.484607	1568.845431	22613.830250	12217.122400	13849.512000
35796	95682	VILLIERS-LE-SEC	1090.890170	NaN	NaN	326.748418	108.969749	2.354558	6.911213	67.235487	4663.232127	85.657725
35797	95690	WY-DIT-JOLI-VILLAGE	1495.103542	NaN	NaN	125.236417	97.728612	4.709115	13.822427	117.450851	504.400972	147.867245

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows